Dataset statistics
| Number of variables | 15 |
|---|---|
| Number of observations | 10000 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 1.1 MiB |
| Average record size in memory | 120.0 B |
Variable types
| NUM | 13 |
|---|---|
| BOOL | 2 |
Reproduction
| Analysis started | 2022-01-12 16:56:03.262455 |
|---|---|
| Analysis finished | 2022-01-12 16:56:25.116193 |
| Duration | 21.85 seconds |
| Version | pandas-profiling v2.7.1 |
| Command line | pandas_profiling --config_file config.yaml [YOUR_FILE.csv] |
| Download configuration | config.yaml |
Total_time_spent is highly correlated with Replay_time_spent | High correlation |
Replay_time_spent is highly correlated with Total_time_spent | High correlation |
Live_sessions is highly correlated with Live_time_spent | High correlation |
Live_time_spent is highly correlated with Live_sessions | High correlation |
Replay_time_spent is highly skewed (γ1 = 57.9354469) | Skewed |
Total_time_spent is highly skewed (γ1 = 42.41175654) | Skewed |
user is uniformly distributed | Uniform |
user has unique values | Unique |
Grade has 188 (1.9%) zeros | Zeros |
Activated_subjects has 5767 (57.7%) zeros | Zeros |
Live_time_spent has 1283 (12.8%) zeros | Zeros |
Replay_time_spent has 3032 (30.3%) zeros | Zeros |
Live_sessions has 1897 (19.0%) zeros | Zeros |
Replay_sessions has 3027 (30.3%) zeros | Zeros |
Competition has 4561 (45.6%) zeros | Zeros |
Breakouts has 6956 (69.6%) zeros | Zeros |
Avg_ranking has 7023 (70.2%) zeros | Zeros |
Paid_amount has 9691 (96.9%) zeros | Zeros |
| Distinct count | 10000 |
|---|---|
| Unique (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5000.5 |
|---|---|
| Minimum | 1 |
| Maximum | 10000 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 78.2 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 500.95 |
| Q1 | 2500.75 |
| median | 5000.5 |
| Q3 | 7500.25 |
| 95-th percentile | 9500.05 |
| Maximum | 10000 |
| Range | 9999 |
| Interquartile range (IQR) | 4999.5 |
Descriptive statistics
| Standard deviation | 2886.89568 |
|---|---|
| Coefficient of variation (CV) | 0.5773214038 |
| Kurtosis | -1.2 |
| Mean | 5000.5 |
| Median Absolute Deviation (MAD) | 2500 |
| Skewness | 0 |
| Sum | 50005000 |
| Variance | 8334166.667 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 2047 | 1 | < 0.1% | |
| 5424 | 1 | < 0.1% | |
| 1338 | 1 | < 0.1% | |
| 7481 | 1 | < 0.1% | |
| 5432 | 1 | < 0.1% | |
| 9526 | 1 | < 0.1% | |
| 3379 | 1 | < 0.1% | |
| 1330 | 1 | < 0.1% | |
| 7473 | 1 | < 0.1% | |
| 9518 | 1 | < 0.1% | |
| Other values (9990) | 9990 | 99.9% |
| Value | Count | Frequency (%) | |
| 1 | 1 | < 0.1% | |
| 2 | 1 | < 0.1% | |
| 3 | 1 | < 0.1% | |
| 4 | 1 | < 0.1% | |
| 5 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 10000 | 1 | < 0.1% | |
| 9999 | 1 | < 0.1% | |
| 9998 | 1 | < 0.1% | |
| 9997 | 1 | < 0.1% | |
| 9996 | 1 | < 0.1% |
| Distinct count | 14 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 9.7978 |
|---|---|
| Minimum | 0 |
| Maximum | 13 |
| Zeros | 188 |
| Zeros (%) | 1.9% |
| Memory size | 78.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 5 |
| Q1 | 8 |
| median | 11 |
| Q3 | 12 |
| 95-th percentile | 12 |
| Maximum | 13 |
| Range | 13 |
| Interquartile range (IQR) | 4 |
Descriptive statistics
| Standard deviation | 2.631920945 |
|---|---|
| Coefficient of variation (CV) | 0.268623665 |
| Kurtosis | 2.905532665 |
| Mean | 9.7978 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | -1.640735588 |
| Sum | 97978 |
| Variance | 6.927007861 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 12 | 3240 | 32.4% | |
| 11 | 2045 | 20.4% | |
| 10 | 1255 | 12.6% | |
| 9 | 854 | 8.5% | |
| 8 | 821 | 8.2% | |
| 7 | 784 | 7.8% | |
| 6 | 263 | 2.6% | |
| 0 | 188 | 1.9% | |
| 5 | 181 | 1.8% | |
| 4 | 140 | 1.4% | |
| Other values (4) | 229 | 2.3% |
| Value | Count | Frequency (%) | |
| 0 | 188 | 1.9% | |
| 1 | 72 | 0.7% | |
| 2 | 25 | 0.2% | |
| 3 | 57 | 0.6% | |
| 4 | 140 | 1.4% |
| Value | Count | Frequency (%) | |
| 13 | 75 | 0.8% | |
| 12 | 3240 | 32.4% | |
| 11 | 2045 | 20.4% | |
| 10 | 1255 | 12.6% | |
| 9 | 854 | 8.5% |
Active_subjects
Real number (ℝ≥0)
| Distinct count | 19 |
|---|---|
| Unique (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.191 |
|---|---|
| Minimum | 0 |
| Maximum | 18 |
| Zeros | 72 |
| Zeros (%) | 0.7% |
| Memory size | 78.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 3 |
| Q3 | 4 |
| 95-th percentile | 8 |
| Maximum | 18 |
| Range | 18 |
| Interquartile range (IQR) | 3 |
Descriptive statistics
| Standard deviation | 2.275617904 |
|---|---|
| Coefficient of variation (CV) | 0.7131362907 |
| Kurtosis | 2.152427174 |
| Mean | 3.191 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 1.336576496 |
| Sum | 31910 |
| Variance | 5.178436844 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 1 | 2626 | 26.3% | |
| 2 | 2216 | 22.2% | |
| 3 | 1522 | 15.2% | |
| 4 | 1273 | 12.7% | |
| 5 | 726 | 7.3% | |
| 6 | 586 | 5.9% | |
| 7 | 440 | 4.4% | |
| 8 | 243 | 2.4% | |
| 9 | 137 | 1.4% | |
| 0 | 72 | 0.7% | |
| Other values (9) | 159 | 1.6% |
| Value | Count | Frequency (%) | |
| 0 | 72 | 0.7% | |
| 1 | 2626 | 26.3% | |
| 2 | 2216 | 22.2% | |
| 3 | 1522 | 15.2% | |
| 4 | 1273 | 12.7% |
| Value | Count | Frequency (%) | |
| 18 | 1 | < 0.1% | |
| 17 | 2 | < 0.1% | |
| 16 | 3 | < 0.1% | |
| 15 | 3 | < 0.1% | |
| 14 | 6 | 0.1% |
| Distinct count | 13 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.7952 |
|---|---|
| Minimum | 0 |
| Maximum | 12 |
| Zeros | 5767 |
| Zeros (%) | 57.7% |
| Memory size | 78.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 1 |
| 95-th percentile | 4 |
| Maximum | 12 |
| Range | 12 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 1.341952698 |
|---|---|
| Coefficient of variation (CV) | 1.68756627 |
| Kurtosis | 9.286688921 |
| Mean | 0.7952 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 2.67919957 |
| Sum | 7952 |
| Variance | 1.800837044 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 0 | 5767 | 57.7% | |
| 1 | 2567 | 25.7% | |
| 2 | 775 | 7.8% | |
| 3 | 359 | 3.6% | |
| 4 | 237 | 2.4% | |
| 5 | 125 | 1.2% | |
| 6 | 76 | 0.8% | |
| 7 | 53 | 0.5% | |
| 8 | 26 | 0.3% | |
| 9 | 7 | 0.1% | |
| Other values (3) | 8 | 0.1% |
| Value | Count | Frequency (%) | |
| 0 | 5767 | 57.7% | |
| 1 | 2567 | 25.7% | |
| 2 | 775 | 7.8% | |
| 3 | 359 | 3.6% | |
| 4 | 237 | 2.4% |
| Value | Count | Frequency (%) | |
| 12 | 2 | < 0.1% | |
| 11 | 3 | < 0.1% | |
| 10 | 3 | < 0.1% | |
| 9 | 7 | 0.1% | |
| 8 | 26 | 0.3% |
| Distinct count | 5614 |
|---|---|
| Unique (%) | 56.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 306.0726800004901 |
|---|---|
| Minimum | 0.0 |
| Maximum | 50791.68333 |
| Zeros | 1283 |
| Zeros (%) | 12.8% |
| Memory size | 78.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1.8 |
| median | 24.275 |
| Q3 | 172.8375 |
| 95-th percentile | 1195.753333 |
| Maximum | 50791.68333 |
| Range | 50791.68333 |
| Interquartile range (IQR) | 171.0375 |
Descriptive statistics
| Standard deviation | 1364.086468 |
|---|---|
| Coefficient of variation (CV) | 4.456740366 |
| Kurtosis | 342.9925059 |
| Mean | 306.07268 |
| Median Absolute Deviation (MAD) | 24.275 |
| Skewness | 15.1074704 |
| Sum | 3060726.8 |
| Variance | 1860731.891 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 0 | 1283 | 12.8% | |
| 0.25 | 28 | 0.3% | |
| 0.316666667 | 27 | 0.3% | |
| 0.383333333 | 22 | 0.2% | |
| 0.366666667 | 22 | 0.2% | |
| 0.3 | 22 | 0.2% | |
| 0.566666667 | 21 | 0.2% | |
| 0.716666667 | 21 | 0.2% | |
| 0.35 | 19 | 0.2% | |
| 0.2 | 19 | 0.2% | |
| Other values (5604) | 8516 | 85.2% |
| Value | Count | Frequency (%) | |
| 0 | 1283 | 12.8% | |
| 0.016666667 | 9 | 0.1% | |
| 0.033333333 | 7 | 0.1% | |
| 0.05 | 8 | 0.1% | |
| 0.066666667 | 6 | 0.1% |
| Value | Count | Frequency (%) | |
| 50791.68333 | 1 | < 0.1% | |
| 31614.26667 | 1 | < 0.1% | |
| 28555.56667 | 1 | < 0.1% | |
| 27759.25 | 1 | < 0.1% | |
| 26889.1 | 1 | < 0.1% |
| Distinct count | 2928 |
|---|---|
| Unique (%) | 29.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 122.3781466665756 |
|---|---|
| Minimum | 0.0 |
| Maximum | 222230.85 |
| Zeros | 3032 |
| Zeros (%) | 30.3% |
| Memory size | 78.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 1.55 |
| Q3 | 13.51666667 |
| 95-th percentile | 248.6316667 |
| Maximum | 222230.85 |
| Range | 222230.85 |
| Interquartile range (IQR) | 13.51666667 |
Descriptive statistics
| Standard deviation | 2921.34401 |
|---|---|
| Coefficient of variation (CV) | 23.87145164 |
| Kurtosis | 3844.147721 |
| Mean | 122.3781467 |
| Median Absolute Deviation (MAD) | 1.55 |
| Skewness | 57.9354469 |
| Sum | 1223781.467 |
| Variance | 8534250.826 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 0 | 3032 | 30.3% | |
| 0.166666667 | 43 | 0.4% | |
| 2 | 40 | 0.4% | |
| 0.35 | 39 | 0.4% | |
| 0.266666667 | 36 | 0.4% | |
| 0.483333333 | 35 | 0.4% | |
| 0.55 | 35 | 0.4% | |
| 0.233333333 | 34 | 0.3% | |
| 0.2 | 34 | 0.3% | |
| 0.25 | 33 | 0.3% | |
| Other values (2918) | 6639 | 66.4% |
| Value | Count | Frequency (%) | |
| 0 | 3032 | 30.3% | |
| 0.016666667 | 20 | 0.2% | |
| 0.033333333 | 24 | 0.2% | |
| 0.05 | 19 | 0.2% | |
| 0.066666667 | 18 | 0.2% |
| Value | Count | Frequency (%) | |
| 222230.85 | 1 | < 0.1% | |
| 123249.1 | 1 | < 0.1% | |
| 90530.03333 | 1 | < 0.1% | |
| 87507.03333 | 1 | < 0.1% | |
| 57928.36667 | 1 | < 0.1% |
| Distinct count | 6227 |
|---|---|
| Unique (%) | 62.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 428.4508266748547 |
|---|---|
| Minimum | 0.016666667 |
| Maximum | 224290.7167 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 78.2 KiB |
Quantile statistics
| Minimum | 0.016666667 |
|---|---|
| 5-th percentile | 0.5 |
| Q1 | 4.879166667 |
| median | 38.49166666 |
| Q3 | 226.6583333 |
| 95-th percentile | 1532.294167 |
| Maximum | 224290.7167 |
| Range | 224290.7 |
| Interquartile range (IQR) | 221.7791666 |
Descriptive statistics
| Standard deviation | 3308.242143 |
|---|---|
| Coefficient of variation (CV) | 7.721404505 |
| Kurtosis | 2427.70382 |
| Mean | 428.4508267 |
| Median Absolute Deviation (MAD) | 37.45833333 |
| Skewness | 42.41175654 |
| Sum | 4284508.267 |
| Variance | 10944466.08 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 0.25 | 31 | 0.3% | |
| 0.316666667 | 29 | 0.3% | |
| 0.35 | 27 | 0.3% | |
| 0.3 | 26 | 0.3% | |
| 0.816666667 | 26 | 0.3% | |
| 0.233333333 | 25 | 0.2% | |
| 0.216666667 | 24 | 0.2% | |
| 1.033333333 | 22 | 0.2% | |
| 0.4 | 22 | 0.2% | |
| 0.166666667 | 21 | 0.2% | |
| Other values (6217) | 9747 | 97.5% |
| Value | Count | Frequency (%) | |
| 0.016666667 | 11 | 0.1% | |
| 0.033333333 | 9 | 0.1% | |
| 0.05 | 10 | 0.1% | |
| 0.066666667 | 6 | 0.1% | |
| 0.083333333 | 11 | 0.1% |
| Value | Count | Frequency (%) | |
| 224290.7167 | 1 | < 0.1% | |
| 123917.0667 | 1 | < 0.1% | |
| 90597.83333 | 1 | < 0.1% | |
| 89434.56667 | 1 | < 0.1% | |
| 65437.33333 | 1 | < 0.1% |
| Distinct count | 211 |
|---|---|
| Unique (%) | 2.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 10.9606 |
|---|---|
| Minimum | 0 |
| Maximum | 997 |
| Zeros | 1897 |
| Zeros (%) | 19.0% |
| Memory size | 78.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| median | 2 |
| Q3 | 8 |
| 95-th percentile | 40 |
| Maximum | 997 |
| Range | 997 |
| Interquartile range (IQR) | 7 |
Descriptive statistics
| Standard deviation | 40.08281067 |
|---|---|
| Coefficient of variation (CV) | 3.656990554 |
| Kurtosis | 223.222639 |
| Mean | 10.9606 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | 12.79587069 |
| Sum | 109606 |
| Variance | 1606.631711 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 1 | 2008 | 20.1% | |
| 0 | 1897 | 19.0% | |
| 2 | 1125 | 11.2% | |
| 3 | 772 | 7.7% | |
| 4 | 559 | 5.6% | |
| 5 | 437 | 4.4% | |
| 6 | 292 | 2.9% | |
| 7 | 261 | 2.6% | |
| 8 | 234 | 2.3% | |
| 9 | 192 | 1.9% | |
| Other values (201) | 2223 | 22.2% |
| Value | Count | Frequency (%) | |
| 0 | 1897 | 19.0% | |
| 1 | 2008 | 20.1% | |
| 2 | 1125 | 11.2% | |
| 3 | 772 | 7.7% | |
| 4 | 559 | 5.6% |
| Value | Count | Frequency (%) | |
| 997 | 2 | < 0.1% | |
| 958 | 1 | < 0.1% | |
| 941 | 1 | < 0.1% | |
| 733 | 1 | < 0.1% | |
| 732 | 1 | < 0.1% |
| Distinct count | 83 |
|---|---|
| Unique (%) | 0.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.333 |
|---|---|
| Minimum | 0 |
| Maximum | 380 |
| Zeros | 3027 |
| Zeros (%) | 30.3% |
| Memory size | 78.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 1 |
| Q3 | 3 |
| 95-th percentile | 13 |
| Maximum | 380 |
| Range | 380 |
| Interquartile range (IQR) | 3 |
Descriptive statistics
| Standard deviation | 8.39148096 |
|---|---|
| Coefficient of variation (CV) | 2.517696057 |
| Kurtosis | 478.9328544 |
| Mean | 3.333 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 15.08380696 |
| Sum | 33330 |
| Variance | 70.4169527 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 0 | 3027 | 30.3% | |
| 1 | 2398 | 24.0% | |
| 2 | 1352 | 13.5% | |
| 3 | 832 | 8.3% | |
| 4 | 530 | 5.3% | |
| 5 | 391 | 3.9% | |
| 6 | 273 | 2.7% | |
| 7 | 188 | 1.9% | |
| 8 | 163 | 1.6% | |
| 9 | 112 | 1.1% | |
| Other values (73) | 734 | 7.3% |
| Value | Count | Frequency (%) | |
| 0 | 3027 | 30.3% | |
| 1 | 2398 | 24.0% | |
| 2 | 1352 | 13.5% | |
| 3 | 832 | 8.3% | |
| 4 | 530 | 5.3% |
| Value | Count | Frequency (%) | |
| 380 | 1 | < 0.1% | |
| 164 | 1 | < 0.1% | |
| 163 | 1 | < 0.1% | |
| 144 | 1 | < 0.1% | |
| 141 | 1 | < 0.1% |
| Distinct count | 132 |
|---|---|
| Unique (%) | 1.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.2554 |
|---|---|
| Minimum | 0 |
| Maximum | 491 |
| Zeros | 4561 |
| Zeros (%) | 45.6% |
| Memory size | 78.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 1 |
| Q3 | 3 |
| 95-th percentile | 16 |
| Maximum | 491 |
| Range | 491 |
| Interquartile range (IQR) | 3 |
Descriptive statistics
| Standard deviation | 17.66681019 |
|---|---|
| Coefficient of variation (CV) | 4.151621515 |
| Kurtosis | 297.5883704 |
| Mean | 4.2554 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 14.62490177 |
| Sum | 42554 |
| Variance | 312.1161825 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 0 | 4561 | 45.6% | |
| 1 | 1872 | 18.7% | |
| 2 | 876 | 8.8% | |
| 3 | 531 | 5.3% | |
| 4 | 358 | 3.6% | |
| 5 | 276 | 2.8% | |
| 6 | 197 | 2.0% | |
| 7 | 169 | 1.7% | |
| 8 | 153 | 1.5% | |
| 9 | 113 | 1.1% | |
| Other values (122) | 894 | 8.9% |
| Value | Count | Frequency (%) | |
| 0 | 4561 | 45.6% | |
| 1 | 1872 | 18.7% | |
| 2 | 876 | 8.8% | |
| 3 | 531 | 5.3% | |
| 4 | 358 | 3.6% |
| Value | Count | Frequency (%) | |
| 491 | 1 | < 0.1% | |
| 489 | 1 | < 0.1% | |
| 446 | 1 | < 0.1% | |
| 418 | 1 | < 0.1% | |
| 405 | 1 | < 0.1% |
| Distinct count | 107 |
|---|---|
| Unique (%) | 1.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.6142 |
|---|---|
| Minimum | 0 |
| Maximum | 516 |
| Zeros | 6956 |
| Zeros (%) | 69.6% |
| Memory size | 78.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 1 |
| 95-th percentile | 11 |
| Maximum | 516 |
| Range | 516 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 13.68793243 |
|---|---|
| Coefficient of variation (CV) | 5.235992821 |
| Kurtosis | 506.6251412 |
| Mean | 2.6142 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 18.37359931 |
| Sum | 26142 |
| Variance | 187.3594943 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 0 | 6956 | 69.6% | |
| 1 | 925 | 9.2% | |
| 2 | 477 | 4.8% | |
| 3 | 311 | 3.1% | |
| 4 | 225 | 2.2% | |
| 5 | 158 | 1.6% | |
| 6 | 125 | 1.2% | |
| 8 | 93 | 0.9% | |
| 7 | 90 | 0.9% | |
| 10 | 61 | 0.6% | |
| Other values (97) | 579 | 5.8% |
| Value | Count | Frequency (%) | |
| 0 | 6956 | 69.6% | |
| 1 | 925 | 9.2% | |
| 2 | 477 | 4.8% | |
| 3 | 311 | 3.1% | |
| 4 | 225 | 2.2% |
| Value | Count | Frequency (%) | |
| 516 | 1 | < 0.1% | |
| 499 | 1 | < 0.1% | |
| 357 | 1 | < 0.1% | |
| 301 | 1 | < 0.1% | |
| 266 | 1 | < 0.1% |
| Distinct count | 1506 |
|---|---|
| Unique (%) | 15.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.4059768533100998 |
|---|---|
| Minimum | 0.0 |
| Maximum | 43.0 |
| Zeros | 7023 |
| Zeros (%) | 70.2% |
| Memory size | 78.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 1 |
| 95-th percentile | 7.261132538 |
| Maximum | 43 |
| Range | 43 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 3.19816567 |
|---|---|
| Coefficient of variation (CV) | 2.274692974 |
| Kurtosis | 23.72502162 |
| Mean | 1.405976853 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 3.95311191 |
| Sum | 14059.76853 |
| Variance | 10.22826366 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 0 | 7023 | 70.2% | |
| 1 | 587 | 5.9% | |
| 4 | 52 | 0.5% | |
| 5 | 39 | 0.4% | |
| 2 | 35 | 0.4% | |
| 3 | 29 | 0.3% | |
| 8 | 28 | 0.3% | |
| 9 | 28 | 0.3% | |
| 5.5 | 26 | 0.3% | |
| 7 | 26 | 0.3% | |
| Other values (1496) | 2127 | 21.3% |
| Value | Count | Frequency (%) | |
| 0 | 7023 | 70.2% | |
| 1 | 587 | 5.9% | |
| 1.04 | 1 | < 0.1% | |
| 1.052631579 | 1 | < 0.1% | |
| 1.0625 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 43 | 1 | < 0.1% | |
| 40.5 | 1 | < 0.1% | |
| 37 | 1 | < 0.1% | |
| 34.30769231 | 1 | < 0.1% | |
| 33.35294118 | 1 | < 0.1% |
Is_Converted
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 78.2 KiB |
| 0 | |
|---|---|
| 1 | 312 |
| Value | Count | Frequency (%) | |
| 0 | 9688 | 96.9% | |
| 1 | 312 | 3.1% |
Is_Activated
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 78.2 KiB |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 5405 | 54.0% | |
| 1 | 4595 | 46.0% |
| Distinct count | 111 |
|---|---|
| Unique (%) | 1.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 8.179269999999999 |
|---|---|
| Minimum | 0.0 |
| Maximum | 1949.0 |
| Zeros | 9691 |
| Zeros (%) | 96.9% |
| Memory size | 78.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 1949 |
| Range | 1949 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 56.67356806 |
|---|---|
| Coefficient of variation (CV) | 6.928927405 |
| Kurtosis | 302.5248565 |
| Mean | 8.17927 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 13.17386999 |
| Sum | 81792.7 |
| Variance | 3211.893316 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 0 | 9691 | 96.9% | |
| 211.65 | 50 | 0.5% | |
| 254.15 | 19 | 0.2% | |
| 296.65 | 18 | 0.2% | |
| 169.15 | 12 | 0.1% | |
| 127.49 | 10 | 0.1% | |
| 126.65 | 9 | 0.1% | |
| 212.49 | 9 | 0.1% | |
| 249 | 7 | 0.1% | |
| 169.99 | 6 | 0.1% | |
| Other values (101) | 169 | 1.7% |
| Value | Count | Frequency (%) | |
| 0 | 9691 | 96.9% | |
| 25.49 | 1 | < 0.1% | |
| 29.99 | 1 | < 0.1% | |
| 49 | 1 | < 0.1% | |
| 49.99 | 2 | < 0.1% |
| Value | Count | Frequency (%) | |
| 1949 | 1 | < 0.1% | |
| 1844.75 | 1 | < 0.1% | |
| 1086.3 | 1 | < 0.1% | |
| 923.15 | 1 | < 0.1% | |
| 787.54 | 1 | < 0.1% |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.First rows
| user | Grade | Active_subjects | Activated_subjects | Live_time_spent | Replay_time_spent | Total_time_spent | Live_sessions | Replay_sessions | Competition | Breakouts | Avg_ranking | Is_Converted | Is_Activated | Paid_amount | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 1 | 6 | 1 | 1 | 81.816667 | 1.483333 | 83.300000 | 2 | 1 | 0 | 2 | 3.857143 | 0 | 1 | 0.00 |
| 1 | 2 | 12 | 1 | 0 | 0.000000 | 13.800000 | 13.800000 | 0 | 1 | 0 | 0 | 0.000000 | 0 | 0 | 0.00 |
| 2 | 3 | 12 | 1 | 0 | 0.000000 | 55.183333 | 55.183333 | 0 | 2 | 0 | 0 | 0.000000 | 0 | 0 | 0.00 |
| 3 | 4 | 12 | 1 | 0 | 7.216667 | 0.000000 | 7.216667 | 0 | 0 | 2 | 0 | 0.000000 | 0 | 0 | 0.00 |
| 4 | 5 | 9 | 2 | 0 | 0.000000 | 0.250000 | 0.250000 | 0 | 1 | 0 | 0 | 0.000000 | 0 | 0 | 0.00 |
| 5 | 6 | 10 | 5 | 0 | 3.950000 | 2.616667 | 6.566667 | 1 | 1 | 1 | 0 | 0.000000 | 0 | 0 | 0.00 |
| 6 | 7 | 12 | 1 | 1 | 784.500000 | 2278.983333 | 3063.483333 | 19 | 35 | 1 | 13 | 5.064516 | 1 | 1 | 296.64 |
| 7 | 8 | 11 | 2 | 1 | 0.000000 | 64.700000 | 64.700000 | 0 | 1 | 0 | 0 | 0.000000 | 0 | 1 | 0.00 |
| 8 | 9 | 12 | 1 | 0 | 0.000000 | 1.900000 | 1.900000 | 0 | 1 | 0 | 0 | 0.000000 | 0 | 0 | 0.00 |
| 9 | 10 | 11 | 2 | 0 | 3.283333 | 0.000000 | 3.283333 | 2 | 0 | 0 | 0 | 0.000000 | 0 | 0 | 0.00 |
Last rows
| user | Grade | Active_subjects | Activated_subjects | Live_time_spent | Replay_time_spent | Total_time_spent | Live_sessions | Replay_sessions | Competition | Breakouts | Avg_ranking | Is_Converted | Is_Activated | Paid_amount | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9990 | 9991 | 11 | 1 | 0 | 25.600000 | 25.766667 | 51.366667 | 1 | 1 | 0 | 1 | 1.000000 | 0 | 0 | 0.0 |
| 9991 | 9992 | 12 | 3 | 1 | 314.316667 | 0.166667 | 314.483333 | 5 | 1 | 13 | 4 | 5.227273 | 0 | 1 | 0.0 |
| 9992 | 9993 | 11 | 1 | 0 | 0.000000 | 0.133333 | 0.133333 | 0 | 1 | 0 | 0 | 0.000000 | 0 | 0 | 0.0 |
| 9993 | 9994 | 12 | 3 | 0 | 0.000000 | 3.916667 | 3.916667 | 0 | 3 | 0 | 0 | 0.000000 | 0 | 0 | 0.0 |
| 9994 | 9995 | 12 | 3 | 1 | 1246.800000 | 612.800000 | 1859.600000 | 20 | 12 | 14 | 6 | 2.344828 | 0 | 1 | 0.0 |
| 9995 | 9996 | 12 | 2 | 1 | 0.000000 | 106.200000 | 106.200000 | 0 | 3 | 0 | 0 | 0.000000 | 0 | 1 | 0.0 |
| 9996 | 9997 | 10 | 4 | 0 | 68.316667 | 0.000000 | 68.316667 | 3 | 0 | 1 | 3 | 1.000000 | 0 | 1 | 0.0 |
| 9997 | 9998 | 12 | 2 | 1 | 0.000000 | 175.466667 | 175.466667 | 0 | 6 | 0 | 0 | 0.000000 | 0 | 1 | 0.0 |
| 9998 | 9999 | 11 | 1 | 0 | 0.000000 | 1.400000 | 1.400000 | 0 | 2 | 0 | 0 | 0.000000 | 0 | 0 | 0.0 |
| 9999 | 10000 | 11 | 3 | 0 | 16.200000 | 13.350000 | 29.550000 | 0 | 2 | 1 | 0 | 0.000000 | 0 | 0 | 0.0 |